insert into staff (lastname, firstname, middlename, emailaddress, telephonenumber, extension, locationid)
values ('Bloggs','Jeff','Joe','jeff@initech.com','01211 644711','4711',1)

insert into staff (lastname, firstname, middlename, emailaddress, telephonenumber, extension, locationid)
values ('Doe','Bob','John','bob@initech.com','01211 645611','5611',1)

insert into staff (lastname, firstname, middlename, emailaddress, telephonenumber, extension, locationid)
values ('Jameson','Trisha','Sarah','trisha@initech.com','01211 633211','3211',2)

insert into staff (lastname, firstname, middlename, emailaddress, telephonenumber, extension, locationid)
values ('Foo','Dave','Mike','dave@initech.com','03251 445511','5511',2)

insert into staff (lastname, firstname, middlename, emailaddress, telephonenumber, extension, locationid)
values ('Smith','rob','Derek','rob@initech.com','01151 955241','5241',4)

insert into staff (lastname, firstname, middlename, emailaddress, telephonenumber, extension, locationid)
values ('Blythe','Sue','Dolly','sue@initech.com','03251 558441','8441',1)

